---
layout: page
title: DAX Studio
subtitle: The ultimate tool for working with DAX queries
use-site-title: true
smimg: "/img/daxstudio-logo-144.png"
js-footer: "/js/index-footer.js"
---

{% assign download = site.github.latest_release %}

{% assign exe_assets = download.assets | where_exp: "item", "item.browser_download_url contains '.exe'" %}
{% assign installer = exe_assets[0] %}
{% assign zip_assets = download.assets | where_exp: "item", "item.browser_download_url contains '.zip'" %}
{% assign portable = zip_assets[0] %}

<!-- Installer Download link -->
<div class="main-explain-area jumbotron center">
  <div class="centered">
    <div style="padding-bottom:10px">Download the latest release of DAX Studio here:</div>
  
    <a href="{{ installer.browser_download_url }}">
      <button class="btn btn-lg btn-success"> 
        <h3><i class="fa fa-download"></i>&nbsp; {{download.name}}</h3>
        <div>(installer)</div>
      </button>
    </a>
    {% assign download_count = installer.download_count %}
    {% assign download_size = installer.size %}
    <div class="download-info">
      <i class="fa fa-download" title="downloads"></i> <span>Size: {% include filesize.html number=download_size %} | </span>
      <i class="fa fa-calendar" title="release date"></i><span>{% if installer.created_at != nil %}{{ installer.created_at | date_to_string }} {% else %}N/A{% endif %} </span>
      <span id="download_cnt"></span> 
    </div>
    <div>The details of the new features and fixes included in this release are available in the <a href="/changelog/latest">changelog</a></div>
  </div>
</div>

<!-- Portable Version download link -->

  {% if portable != nil  %}  
  <div class="centered">

    <a href="{{ portable.browser_download_url }}">
      
        <div><i class="fa fa-download"></i>&nbsp; {{download.name}} (portable)</div>
      
    </a>
    {% assign download_count_1 = portable.download_count %}
    {% assign download_size_1 = portable.size %}
    <div class="download-info">
      <i class="fa fa-download" title="downloads"></i> <span>Size: {% include filesize.html number=download_size_1 %} | </span>
      <i class="fa fa-calendar" title="release date"></i>&nbsp;<span>{% if portable.created_at != nil %}{{ portable.created_at | date_to_string }} {% else %}N/A{% endif %} </span>
      <span id="download_cnt_zip"></span> 
    </div>
  </div>

{% endif %}

<blockquote>
<p>If you would like to support the on-going development of DAX Studio there are a number of ways you can <a href="/contributing">contribute</a> to the project including becoming a financial <a href="/sponsors">sponsor</a></p>
</blockquote>

<div>DAX Studio is the ultimate tool for executing and analyzing DAX queries against Microsoft Tabular models</div>

<!-- hero image --> 
<img src="/img/home_hero_image.png" alt="Feature Collage"/>
<div>Some of the many features DAX Studio supports includes:</div>
<hr>
<div class="row">
  <div class="pull-left col-2 idx-thumb">
    <img class="img" src="img/connection-dialog.png" />
  </div>
  <div class="col-lg-8">
    <a href="/documentation/features/connection-dialog/"><h4>Connects to multiple different data sources</h4></a>
    <div>DAX Studio is a client tool for executing DAX queries against various data sources including:</div>
    <ul>
      <li>PowerPivot in Excel</li>
      <li>Power BI Desktop / SSDT Integrated Workspaces</li>
      <li>Analysis Services Tabular</li>
      <li>Azure Analysis Services</li>
    </ul>
    <span>DAX Studio will scan the local machine for any running instances of Power BI Desktop or SSDT Integrated Workspaces</span>
  </div>
</div>

<div class="row"><div class="col">&nbsp;</div></div>
<hr>

<div class="row">
  <div class="img pull-right col-2 idx-thumb">
    <img src="img/dax-formatter.gif" />
  </div>
  <div class="col-lg-8">
    <a href="/documentation/features/daxformatter-support/"><h4>Integrated DaxFormatter Support</h4></a>
    <div>DAX Studio has integrated support for DaxFomatter.com allowing you to consistently format your DAX directly in the editor</div>
  </div>
</div>

<div class="row"><div class="col">&nbsp;</div></div>
<hr>
<div class="row">
    <div class="img pull-left col-2 idx-thumb">
      <img src="img/server-timings.png" />
    </div>
    <div class="col-lg-8">
      <a href="/documentation/features/server-timings-trace/"><h4>Server Timings</h4></a>
      <div>DAX Studio can collect detailed query execution statistics to help when doing performance tuning</div>
    </div>
</div>
  
<div class="row"><div class="col">&nbsp;</div></div>
<hr>
<div class="row">
    <div class="img pull-right col-2 idx-thumb">
      <img src="img/swap-delimiters.gif" />
    </div>
    <div class="col-lg-8">
      <a href="/documentation/features/swap-delimiters/"><h4>Swap Delimiters</h4></a>
      <div>DAX Studio can help you to easily swap the delimiter style for DAX expressions</div>
    </div>
</div>

<div class="row"><div class="col">&nbsp;</div></div>
<hr>
<div class="row" style="margin-top:40px">
  <div class="col-lg-2"><i class="fa fa-info-circle" style="font-size: 48pt"></i></div>
  <div class="col-lg-10"> For information about getting started with DAX Studio you can read through the <a href="https://exceleratorbi.com.au/getting-started-dax-studio/">getting started guide</a> from ExceleratorBI.</div>
</div>
<div class="row"></div>
<hr>
<div class="row">
  <div class="col-lg-2 pull-left"><i class="fa fa-search" style="font-size: 48pt"></i></div>
  <div class="col-lg-10"> Find out more about using DAX Studio by having a look through the full <a href="/documentation/features">Feature List</a>.</div>
</div>
<div class="row"></div>
<hr>
<div class="row">
  <div class="col-lg-2 pull-left"><i class="fa fa-question-circle" style="font-size: 48pt"></i></div> 
  <div class="col-lg-10">If you have an idea for a feature that you would like to see in DAX Studio submit your idea to our <a href="/issues">issues register</a></div>
</div>
<hr>
<div class="row">
  <div class="col-lg-2 pull-left"><i class="fa fa-cogs" style="font-size: 48pt"></i></div> 
  <div class="col-lg-10">Will DAX Studio run on your machine? Probably, but you can double check the <a href="/documentation/Requirements">Requirements</a> for running DAX Studio</div>
</div>
<hr>
<div class="row">
  <div class="col-lg-2 pull-left"><i class="fa fa-heart" style="font-size: 48pt"></i></div> 
  <div class="col-lg-10">Interested in supporting the future development of DAX Studio? There are a number of different ways of <a href="/contributing">helping</a> with this. Including becoming a finanical <a href="/sponsors">sponsor</a>
    
  </div>
</div>

{% if posts.size > 0 %}
<!-- Recent Announcements -->
<h1>Recent Announcements</h1>
{% assign recent = site.posts | where: "index", "false"  %}

<div class="posts"> 
  <ul>
  {% for ann in recent limit: 3 %}
  
    <li>
      <a href="{{ ann.url }}">
        {{ ann.date | date_to_string }} - {{ ann.title }}
      </a>
    </li>
  
  {% endfor %}
  </ul>
</div>

<div>
  <div >
    <a class="btn btn-default" href="/announcements">See all past announcements</a>
  </div>
</div>

{% endif %}
<!-- 2.17.3.683  -->
